UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zpdqPG8SiKuLw6+IhT/ljYmKExG8W96yETQH9V2XYE='
WHERE
key_id = '8b548f917a96bcef57b3e12a11a69b938edcdb2a4f96a3d252023496e7785deb'
AND (
token = '6zpdqPG8SiKuLw6+IhT/ljYmKExG8W96yETQH9V2XYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)