UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xoYVQkjT59UocOfyLYxBOaBAJr5eTvK02T4Aluoo1M='
WHERE
key_id = 'd4f03c3d2ccb5981b56437b594b1567895812a939f7c395ee7442bbd784adf5c'
AND (
token = '9xoYVQkjT59UocOfyLYxBOaBAJr5eTvK02T4Aluoo1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)