UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDsCV52sbwxClj8ywtIGMjPcBTmtBlLJsfi+CnsVQaY='
WHERE
key_id = 'c7db8b6d4cbb8ad8324a2f00bf93a3bbb5b1013edce4abf442bcece82bd0df79'
AND (
token = 'zDsCV52sbwxClj8ywtIGMjPcBTmtBlLJsfi+CnsVQaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)