UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1pjSOdRcpzwLbauZYI7OwWkj32qyGiV8WjrDOTxrn8='
WHERE
key_id = '19c60eee26c9c24f60b5f88514d7e6c46d45ee12aaa7da21c6441f05ca231cd2'
AND (
token = 'x1pjSOdRcpzwLbauZYI7OwWkj32qyGiV8WjrDOTxrn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)