UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BU4rK5OA6Ys1pIKL04mjAh/ynVx1yI07W+76SXX6ODs='
WHERE
key_id = 'c78c88d0590370ba93b315e75a0b76de11ef95ab1c22402843ff0fa2000e01a0'
AND (
token = 'BU4rK5OA6Ys1pIKL04mjAh/ynVx1yI07W+76SXX6ODs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)