UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRxSneFgJ1SOShfawKK+O9iDXUKan9JnAFzz/134/FM='
WHERE
key_id = 'b8fdcbc9ea413e4204da3bc303e05c30e22017d8a30dd8f4b76ac673e652b0b9'
AND (
token = 'lRxSneFgJ1SOShfawKK+O9iDXUKan9JnAFzz/134/FM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)