UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd0kH3Zy2ZfNnnclMMo83UuOHmu8yWZyGYSI037ULCK8='
WHERE
key_id = '05a92ba578ef1d4a6351fb020b0025b56bcc677a333cf6521f6403d450503041'
AND (
token = 'd0kH3Zy2ZfNnnclMMo83UuOHmu8yWZyGYSI037ULCK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)