UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8JE5yvS4sIgi0jlCWuArfULPosOhiEKkAm73ExWwEo='
WHERE
key_id = 'fe0026210dfe2e43595274e22555c1f83e1de71aad9c9693289e0b4a1c2e6d5a'
AND (
token = 'o8JE5yvS4sIgi0jlCWuArfULPosOhiEKkAm73ExWwEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)