UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aB3UbIc0t38CWtW/QxxfV1sU7mS9fja+vpyW7uKwfUY='
WHERE
key_id = 'b23a7862626f056f36afa00b97f956aff470f79bb6dcc33b508a33b9bf8fb9fd'
AND (
token = 'aB3UbIc0t38CWtW/QxxfV1sU7mS9fja+vpyW7uKwfUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)