UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x4QH2CIuCs6qEvrEwh3/VL/HHGskSFG9cdoGl6CVb5w='
WHERE
key_id = '0dda974f910972d33f6734f131d32f493a313d2f8008888f8d1899dc9f4e777b'
AND (
token = 'x4QH2CIuCs6qEvrEwh3/VL/HHGskSFG9cdoGl6CVb5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)