UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NaGf+eOhDZieSnY3s2bldHb+2dd83RCXxJFF/vhjwp4='
WHERE
key_id = 'e24c43f591cd686f223d14786d47bd8a091e75986d628c7c0ed3701671ff02c0'
AND (
token = 'NaGf+eOhDZieSnY3s2bldHb+2dd83RCXxJFF/vhjwp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)