UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/d21JNt/yecuVKQlJ4H5tif8RfswNhGxTZ/vX789ldg='
WHERE
key_id = 'de047ecf50fcdf9872df5bb94052ff85bc732d9dda2149e1be3b13233f3a089f'
AND (
token = '/d21JNt/yecuVKQlJ4H5tif8RfswNhGxTZ/vX789ldg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)