UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k/zdQYic7bZJSV0KkWSQuJfskhNzcMS+enH+MefJnio='
WHERE
key_id = 'f4dd8cd3d86085a1799799c048f8f08122ac67a60fccc087fcef1c9c3ca01bce'
AND (
token = 'k/zdQYic7bZJSV0KkWSQuJfskhNzcMS+enH+MefJnio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)