UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6S5QsEeChQ1/fb8Ij4S9bRbjW1gPSGewFoo2dSCW/GI='
WHERE
key_id = '07469ecf3a1ae910bdc891878cd2476fe17c4af553aa7d30385b8409a52002e5'
AND (
token = '6S5QsEeChQ1/fb8Ij4S9bRbjW1gPSGewFoo2dSCW/GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)