UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXLH0y2FE7EJzzhqnHVKOie+WTFUTmQ2IK8ZIjsxsCs='
WHERE
key_id = 'c2c4ec027585bd22059966951d1b43eb7813aa05b36c3dc99ea5c5f540c56c0b'
AND (
token = 'nXLH0y2FE7EJzzhqnHVKOie+WTFUTmQ2IK8ZIjsxsCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)