UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9iiojuy8hfsfxnGJI6rdB2cLn/WHsAf9g4eg1icVH54='
WHERE
key_id = '4039c0d400b55999bd98d643e748ac3dceac120e1e269e892b68ce2225402626'
AND (
token = '9iiojuy8hfsfxnGJI6rdB2cLn/WHsAf9g4eg1icVH54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)