UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2XU8NCjWGYbiX1lSJjw9N8ZvTIjKpIP4XIvX83y52qs='
WHERE
key_id = 'a1bab511718d1593404faf042cb13067c79802254fae5eb8b97945c984ec1124'
AND (
token = '2XU8NCjWGYbiX1lSJjw9N8ZvTIjKpIP4XIvX83y52qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)