UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/7loV7z9hnXWy673/zCM8feAZJPH8f99kPfJLcPWQFE='
WHERE
key_id = 'bba8b474c61e4f318d123e027254ba0d16b688201628f29c2ac138e7cb36cc20'
AND (
token = '/7loV7z9hnXWy673/zCM8feAZJPH8f99kPfJLcPWQFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)