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