UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dH4LTp0CPv7AYzJ9dDEPuO56KB5DhFUWbPqVKvSBqkc='
WHERE
key_id = '1be995c8d17f55c261bc4358ac85c6f34b54028af5851332f1143f0b76e9e973'
AND (
token = 'dH4LTp0CPv7AYzJ9dDEPuO56KB5DhFUWbPqVKvSBqkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)