UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WQt1clzy4h+4J0BzoCOcfzZnWlUrz0J+BadmKFPyC38='
WHERE
key_id = '93346669598c4fe3cc7c568a039802aae203c4045b9e33d355667a2a1a972291'
AND (
token = 'WQt1clzy4h+4J0BzoCOcfzZnWlUrz0J+BadmKFPyC38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)