UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czdUPeuWgIpodqhSIbuWTT8M0PnZr3lgCdOf+18jk8U='
WHERE
key_id = 'd9010a2d7336f1702c4578205f6e63675dfc1f1ef07906b5f33d72e8f1799381'
AND (
token = 'czdUPeuWgIpodqhSIbuWTT8M0PnZr3lgCdOf+18jk8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)