UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4nRHV+w2oS7OiE8TfHXK3xeHfNEsIwIKy80XxlrsuA='
WHERE
key_id = '0d5e26934265c68e9308c159065dbedd6a00e98f9a639da18f8835f30bf6f981'
AND (
token = 'J4nRHV+w2oS7OiE8TfHXK3xeHfNEsIwIKy80XxlrsuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)