UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CX2jn/HosA42MUITmKKrV+/IFhoyiqwHZgYDvorbwiA='
WHERE
key_id = 'd9b0811061de59aba86e16cc233522ea8ecf1096023770a75468ec19ec733ce7'
AND (
token = 'CX2jn/HosA42MUITmKKrV+/IFhoyiqwHZgYDvorbwiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)