UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rE0z8UijUSSGAG3zo1Gb9Ql0KsUVxVkCww7Jiw5UCsI='
WHERE
key_id = '2e42c7d20c96ccb763a289bf4abcbadf2334b14dc898afea3cb0da9952ab13c7'
AND (
token = 'rE0z8UijUSSGAG3zo1Gb9Ql0KsUVxVkCww7Jiw5UCsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)