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