UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQ+eAOKZoHOYgjUcvZVOnd23DRbzt+eYY3JW+RZq3Xw='
WHERE
key_id = 'a9c802e6ff3edc4210abe94e4dcb53c1c081804fb90059a3ac82a682aebcdf8c'
AND (
token = 'nQ+eAOKZoHOYgjUcvZVOnd23DRbzt+eYY3JW+RZq3Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)