UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZp3A5h4g+tiP9DP2q1eyA01Fjzz287xKtFpKkGpzmw='
WHERE
key_id = '6d92aa9a2fcedbe94a8ca14cab64dcbfc36f268dd5a43af7e4c7efa6ae39ebda'
AND (
token = 'wZp3A5h4g+tiP9DP2q1eyA01Fjzz287xKtFpKkGpzmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)