UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'orj7KSrXzDckBtMxhW+zV+LWMXwE6ZPnvI6uwLVThlg='
WHERE
key_id = 'd488f3365ffe3a0f3e8a31df9ac96b3f809ab3475c3615ef5a4a2c3e8a546887'
AND (
token = 'orj7KSrXzDckBtMxhW+zV+LWMXwE6ZPnvI6uwLVThlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)