UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qjaoogSi6C22Qltg0gIXmXEj1iOD7Nwidbw4uQgRYlQ='
WHERE
key_id = 'a9fce3be76a1814dc1a3da9b0cb3beb44e709bd455ad32ba374fe7417c010356'
AND (
token = 'qjaoogSi6C22Qltg0gIXmXEj1iOD7Nwidbw4uQgRYlQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)