UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHmKdarDsF8aaZP5lm9+r7lh1anWnHmSBjjuXSiGNL0='
WHERE
key_id = '20ed8ec79ded4c7986f3e15c2e01000e93f6acf97d839a69e7a372175b19abdb'
AND (
token = 'XHmKdarDsF8aaZP5lm9+r7lh1anWnHmSBjjuXSiGNL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)