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